package org.jeecg.modules.userReports.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.userReports.entity.UserReports;

import java.util.List;
import java.util.Map;

/**
 * @Description: user_reports
 * @Author: jeecg-boot
 * @Date: 2023-02-25
 * @Version: V1.0
 */
public interface UserReportsMapper extends BaseMapper<UserReports> {
    List<Map<String, Object>> getTableByCalcDate(@Param("tableName") String tableName, @Param("calcDate") String calcDate);

    Page<Map<String, Object>> getTableQueryDate(Page page, @Param("tableName") String tableName, @Param("slotNo") String slotNo, @Param("beginDate") String beginDate, @Param("endDate") String endDate);

    int getTableTotal(@Param("tableName") String tableName, @Param("slotNo") String slotNo, @Param("beginDate") String beginDate, @Param("endDate") String endDate);

    int insertInto(@Param("tableName") String tableName, @Param("params") Map<String, Object> params);

    int createTable(@Param("tableName") String tableName, @Param("cloums") List<String> cloums);

    List<String> getDateList(@Param("tableName") String tableName, @Param("slotNo") String slotNo, @Param("beginDate") String beginDate, @Param("endDate") String endDate);
}
